Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkerID (FK)(PK) | A unique system-assigned identifier for the Worker whose availability is being recorded. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
TimeGroupID (FK)(PK) | A unique identifier for a set of consecutive hours on a set of days of the week on which the Worker will be available to work at the nominated WorkLocation. | ID_GP_TM | Identity | integer | TimeGroup(CO_GP_TM) |
LocationID (FK)(PK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | WorkLocation(LO_LCN_WRK) |
EffectiveDate | The date from which the Worker availability record applies. | DC_EF | EffectiveDate | date | |
ExpirationDate | The date until which the Worker availability record applies. | DC_EP | ExpirationDate | date | |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |